Update query between related tables..URGENT

B

BDP

I have a database for an upcoming conference. I have two related tables which I need to figure a way to run an update or append query to tranfer some data, I will try to explain this as best I can

The first or parent table is a pre registration table called tbl_preg it has a field called companyname which I need to append or update to a second table called tbl_attendees. Both tables have primary keys named registration number, which is an auto number the table are related by this field. I know this should be very simple to do ...PLEASE HELP as time is running out. There are up to three attendees for each registration number


BDP
 
Top