Table Using Relationship? VB or somethingelse?

[QAS]

I am trying to track sales for a C-store. There are 12 departments, some are taxable some are not. how can i go about creating a table or two where when pulled by a form the calculations should already know if it is taxable or not.

right now i have 2 tables

TblDeptInfo:
DepartmentName; Text
DepartmentTaxablel Yes / No

TblDailySales:
Date
dept01; currency
dept02; currency
......
dept12; currency

Now i can not figure out how to link TblDailySales:dept01 .... :dept12 to TblDeptInfoepartmentName and then associate the right tax status

 

[Gerald Stanley]

I definitely recommend that you 'normalise' TblDailySales
so that one row relates to only one department. I would
also recommend that you add a primaryKey column to
TblDeptInfo which would then act as a Foreign Key on
TblDailySales.
So my tables would look like

TblDeptInfo:
DepartmentId; AutoNumber - PrimaryKey
DepartmentName; Text
DepartmentTaxablel Yes / No

TblDailySales:
SalesDate; Date/Time
DepartmentId; Number - Foreign Key to TblDeptInfo
Sales; currency

The link between the two tables is a simple INNER join on
DepartmentId

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
I am trying to track sales for a C-store. There are 12

departments, some are taxable some are not. how can i go
about creating a table or two where when pulled by a form
the calculations should already know if it is taxable or not.

right now i have 2 tables

TblDeptInfo:
DepartmentName; Text
DepartmentTaxablel Yes / No

TblDailySales:
Date
dept01; currency
dept02; currency
......
dept12; currency

Now i can not figure out how to link TblDailySales:dept01

..... :dept12 to TblDeptInfoepartmentName and then
associate the right tax status