Limiting More than One Record Added

[Patriot_BC]

I have a form with a subform in it. The start has person information: Name, Group, etc. The subform has phone numbers. I only want one record per person. If I enter a new person, I want one record. Right now there can be one person with many phone numbers. How do I limit the number of new phone records, but not the number of new people?

 

[Andrew Fergus]

It sounds like you have a one-to-many relationship between the people (one) and phone numbers (many). Firstly I recommend you look at your data tables and your relationships to make sure these are set up correctly (in other words, do the tables and relationships reflect how you want to store the data?). Secondly, in the form design, if you only want one phone number per person, move the phone number field (once the data structures & queries etc are right) into the header part of the form and delete the subform if it is no longer required. If this is not possible then please advise.
HTH, Andrew.