Ok, I am stumped. I am developing a system where it can track prices for natural gas locations. Each employee is assigned a location to enter in prices (up to 5 locations per employee), once a location is assigned, no one else can be assigned that location.
Here are my tables right now.
tblLocation
LocationID
LocationName
tblPrice
PriceID
LocationID
EmployeeID
Price
tblEmployee
EmployeeID
Employee
LocationID
Also I need to create a form that opens just the locations that the particular employee can enter prices for, and somehow get the price for the previous day for that particular location.
Make any sense?
Here are my tables right now.
tblLocation
LocationID
LocationName
tblPrice
PriceID
LocationID
EmployeeID
Price
tblEmployee
EmployeeID
Employee
LocationID
Also I need to create a form that opens just the locations that the particular employee can enter prices for, and somehow get the price for the previous day for that particular location.
Make any sense?