I need a sub form that will only accept one set of records

  • Thread starter Thread starter Kelvin
  • Start date Start date
K

Kelvin

Hi have a database for work order tracking.
On my main form I'm pulling data from our busness system that the user can
only view. Fields are locked.
I have two other tables and subforms, one for comments made by the
technicians.
The other is the contact information for that work order. Name and phone
number.
I want the subform with the contact information to only accept one set of
data for each work order.

Any sugestions on how to accomplish this?

Thanks

Kelvin
 
sounds like to me that if each work order can only have 1 record of
contact information, then it should be in the same table/form as the
main table/form.

if you dont want to do that, then your table with contact information
will need to have the same primary key as your main work order table
so that each work order can only have one record of contact info.
 
Thanks, I'll give the second option a try.

The data in the Main form is from a custom app that I don't have control
over, so I think the second option should work...

Thanks
 
Back
Top