I am having trouble with a db(attached) I am building; I needed to do the following:
Keep track of the orders that Drís submit with all the criteria checked.
Keep Patientís information tied to the Dr who orders the work and the vendor where it was send.
Date when it was picked up from Drís office, estimated date for delivery and delivery
The Drís will have preset settings that will show anytime their name is selected on the form as the provider. This presets must remain constant for every record created.
The settings should have their own table and form so the office manager can change, add or delete at any given moment and be available instantly.
The kicker is that if Dr Smith is selected and option 1 and 2 are displayed as presets, BUT, this particular patient does not need option 1. The manager wants to be able to uncheck option 1 with out affecting the main presets table. So in other words those changes will only record under that specific patient but when another order is entered, the original presets show.
I have created tables, queries and forms but I am not able to come up with a way to save the values entered without changing the presets table.
Sorry for the long description, I understand if unable with this mess