Scooterbug
Registered User.
- Local time
- Today, 11:25
- Joined
- Mar 27, 2009
- Messages
- 853
Based on your post, you have what is called a One (Project) to Many (Inventory) Relationship. In that situation, you should be using a Form bound to Projects and a subform bound to Inventory. The subform should be linked via the ProjectID field.I have two tables: Projects and Inventory
Both tables have a single bound form: Project Details and Inventory Details
Saving duplicate data in multiple tables is a No-No. What you should be doing is storing the ProjectID of the project in the Inventory table. With a correctly setup form/subform situation, you can have the ProjectID automatically saved with each new Inventory item added.When I place text in Text Box "Project Name" in the Projects Details form, I need that field to copy, paste, and save information to Text Box "Project Inventory" in the Inventory Details form. This information needs to be saved in both tables.
I use Project Details (Projects) to collect information about a project via the Data Collection emails. Inventory Details (Inventory), is where I record and continually track the inventory for that project. Having the name of the project copied and pasted automatically from the two text fields would be great.
I would send you my DB but it wont let me convert it down so you can see it as I'm sure this would probably make more sense.
I have been reading a lot here and I see that many people are doing it but I don't understand their methods yet.
Could you help?
Brian
Give me a bit and I can do up a quick little db to illustrate the Form/Subform concept for you if you would like.