Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
MS Access Data Entry Complexity
Name: mickymouse Date: April 16, 2007 at 06:26:22 Pacific OS: Win XP CPU/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!
Name: rousou Date: May 3, 2007 at 06:41:12 Pacific
Reply:
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.
Summary: I had MS Access 2.0 for a long time. Then I got MS Access 2000. There's one thing that bugs me about the newer version: when moving between a form's fields, I cannot add data by pressing the right arr...
Summary: I've got a question about SQL query in MS Access, for example I have the following data: Table1: NAME ______ CITY ____ FAV vahid ______ NY ______ A vahid ______ NY ______ B hamed ______ LA ______ A ha...
Summary: I have an old DOS program that saves data to a .dbf database file. I would now like to add data to the .dbf file through MS Access. I have successfully created a link to the table in Access and have...
0 
