Need data entered in two forms to go to one table....

[Tamarin]

Here's the problem, I have form FIRE and form SAFETY to enter data into table FIRE and table SAFETY, I need the data entered in one of the fields of both forms to go to another single table. Basically the forms are databasing equipment and serial numbers, and I need the serial numbers to also go to a separate table so I can keep from having duplicates.(two places can't have the same equipment). I have thought about just making one form and a field to select where the equipment is but have been told I have to have the two separate forms by my boss.

Steve

 

[Psychpt]

you CAN create one table and have two different forms
you DO NOT need all the fields in one form as long as there are no required fields that you left out

you can select which fields to go in which form.

 

[Tamarin]

Rephrase...When I enter a serial number in form FIRE I need that entry to go to table FIRE and table SERIAL, ALSO when I enter a serial number in form SAFETY I need that entry to table SAFETY AND I need it to also go to table SERIAL. I hope this clarifies it more
Steve Hall
USN

 

[dneufarth]

If these forms are ADD data only seems like you could have the AfterInsert event of FIRE|SAFETY form do a Dlookup or FindFirst action to make sure the serial number does not exist in SERIAL. If not perform an update query to insert a record into SERIAL.

Still need to deal with deletes and changes to FIRE|SAFETY records though.

Sounds like serial number is primary key of SERIAL and should be treated as a foreign key in FIRE|SAFETY.

Dave