One Form, Two Tables

[Ralph]

Hi All,

Another simple one i'm sure, but as I'm in the slow reader's group maybe someone could help?

I have a form [form1] that when populated adds a record to a table [table1]. Nothing amazing there. I have another table [table2] that requires some of the information from [form1] to be added to it as an additional record.

The field names in [table1] and [table2] are different.

I thought i needed an append query... or possibly a lobotomy.

All help welcome!

 

[RainLover]

If you are adding the same information to two different tables then you have something wrong with your structure.

They call it normalisation.

 

[Ralph]

You are right! There is probably a lot of things wrong with the structure...

[Table1] holds information about people. This includes (amongst many other things) their name, the date they started and the amount of licence fee they pay (per month).

The records in [Table2] show changes to licence fee amounts. So everytime a persons licence fee is changed, a new record is created in [table2].

Does that make any sense?

 

[RainLover]

So you are tracking payments,

What is the duplicate data you want in both tables.

 

[RainLover]

I have to go now but I think you need a Form SubForm situation and use a before Update event to fetch the value from the Main and insert it into the Sub.