If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form from a query
First go to the Relationship window and join the two tables with Referential
Integrity enabled. If it won't enable, fix the problem records. Next create a form based on the first table. On this form place a subform based on the second table. If you have RI enabled, then the subform wizard should help. Note: If you are using a bunch of check boxes in the second table for different items, there's a good chance that the tables aren't properly set up. One way to find out is to answer this question: What happens to my queries, forms, and reports if I have to add another client need? If you have to modify these queries, forms, and reports to add another field, then the table has a big problem. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Texas ReEntry Services" wrote: I made a select query that draws data from 2 tables and designed a form to show this data but it wont populate I dont know what I did wrong. Im trying to show client ID (Autonumber) and First and Last names (Text)from 1 table and client needs (several Y / N checkboxes) from 2nd table I have linked the client ID fields in both tables as they are the primary keys. Im using ACCESS 2003 |
Thread Tools | |
Display Modes | |
|
|