Sep 13 2007, 05:09 PM
I have two tables-contacts and properties. A contact can have more than one property so I created a form that shows contacts and a subform that displays their properties. When I scroll through the owners, Is it possible to show their first or only property in the subform rather only the list I have? I attached a sample of what I'm talking about. The form is contacts. Thanks if you can help
Sep 13 2007, 05:26 PM
Is the subform for display only or do you want to add data? If display only base the subform on a query and set Top to 1 to show only one record. If you want to add data leave it as it is and if the subform is in Single form view you will see the first property and will have to navigate to get to a new form or use a command button...
EDIT - I forgot to mention that you have repeating groups in your Contact table and these should be RECORDS in a related table, not FIELDS in each RECORD...
Edited by: Jack Cowley on Thu Sep 13 18:29:08 EDT 2007.
Sep 13 2007, 06:40 PM
Sep 13 2007, 06:44 PM
You are welcome and seriously consider normalizing your structure as it could end up saving problems in the future...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here