spalmateer
Registered User.
- Local time
- Today, 22:50
- Joined
- Dec 5, 2000
- Messages
- 46
Hi,
I have a simple question about record sources for forms. I have a main customer form with a services performed subform. The services performed subform has a one to many relationship with customer number(in tables). I also have three buttons which bring up pop up forms. All the popup forms have a one to one relationship (in tables) with customer number on the main form. Ideally in this situation should I have all these various forms sourced off one query, or should every form have it's own query? What record source is best for filtering the information between forms yet allowing the user to still enter information into the tables? Will sourcing all these forms off one query be inefficient? Thanks in advance for any help and insight!
Scott
I have a simple question about record sources for forms. I have a main customer form with a services performed subform. The services performed subform has a one to many relationship with customer number(in tables). I also have three buttons which bring up pop up forms. All the popup forms have a one to one relationship (in tables) with customer number on the main form. Ideally in this situation should I have all these various forms sourced off one query, or should every form have it's own query? What record source is best for filtering the information between forms yet allowing the user to still enter information into the tables? Will sourcing all these forms off one query be inefficient? Thanks in advance for any help and insight!
Scott
