| Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free! |
MS Access Data Entry Complexity
|
Original Message
|
Name: mickymouse
Date: April 16, 2007 at 06:26:22 Pacific
Subject: MS Access Data Entry ComplexityOS: Win XPCPU/Ram: 256 MB |
Comment: I'm trying a small database program using MS Access 2003. I have a number of tables ( 5 in number ) as one side related to a single table as a many side. This means the many side table has 5 foreign keys added to its fields. I created a form for data entry from the many side table. Access is asking me to fill the foreign keys first if I'm going to proceed to the next record. How could I handle these foreign keys - any one any idea, please!
Report Offensive Message For Removal
|
|
Response Number 1
|
Name: rousou
Date: May 3, 2007 at 06:41:12 Pacific
|
Reply: (edit)Use the subform option (use the tab option to show all of the tables in the minimum space - 1 subform on each tab). main form will be the main table, subforms the 5 tables. when you create the subform it will ask for a link between main and sub, use the foreign key of each table.
Report Offensive Follow Up For Removal
|

Post Locked
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
Go to Database Forum Home