Rusty
Registered User.
- Local time
- Today, 17:17
- Joined
- Apr 15, 2004
- Messages
- 207
Hello there,
I'm working on sorting someone elses database out and it's in a right mess.
There are three tables "tblDetails" – this contains the main info and two tables called "tblProgress" and "tblOutcome"
Each has got a unique ID field called [ReviewID] and each table has only one record per unique review, and so are based on one-to-one relationship.
I have a form with three tabs – tab1 has the fields for "tblDetails", tab2 "tblProgress" and tab3"tblOutcome"
How do I design it so that when I enter a new record and ID number in the [ReviewID] field on tab1 (for "tblDetails"), that this then adds the new record and value to the [ReviewID] fields for "tblProgress" and "tblOutcome" on the other two tabs?
I'm going in circles here - is it to do with the table relationships, should I use subforms, or VBA?
I'm working on sorting someone elses database out and it's in a right mess.
There are three tables "tblDetails" – this contains the main info and two tables called "tblProgress" and "tblOutcome"
Each has got a unique ID field called [ReviewID] and each table has only one record per unique review, and so are based on one-to-one relationship.
I have a form with three tabs – tab1 has the fields for "tblDetails", tab2 "tblProgress" and tab3"tblOutcome"
How do I design it so that when I enter a new record and ID number in the [ReviewID] field on tab1 (for "tblDetails"), that this then adds the new record and value to the [ReviewID] fields for "tblProgress" and "tblOutcome" on the other two tabs?
I'm going in circles here - is it to do with the table relationships, should I use subforms, or VBA?