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
|
|||
|
|||
Access XP Form with lookup
I have a database with about 10 tables for a research project. The primary
database is for notes (memo field) and a page number. Other fields include the key fields for the other tables (i.e. ref_ID, Character_ID, city_ID, etc.) those other tables have only 2 fields--the key field and the data field (i.e. Character_ID and Character, City_ID and City, etc.) I am trying to make a form for inputting data which includes a lookup for each of the 2-field tables plus a text field for "notes" and "page ", but I can't seem to make it work. I made a very complex database with about 30 tables in all sorts of connections using lookups and it works fine. So why can't I make this siimple database work. Please help. I am on a deadline. Thanks, Rob |
#2
|
|||
|
|||
Access XP Form with lookup
Lookups should only be done with queries, not Lookup fields in tables. Have
a look at the following for reasons, one of which may be your problem: http://www.mvps.org/access/lookupfields.htm -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Robbob" wrote in message ... I have a database with about 10 tables for a research project. The primary database is for notes (memo field) and a page number. Other fields include the key fields for the other tables (i.e. ref_ID, Character_ID, city_ID, etc.) those other tables have only 2 fields--the key field and the data field (i.e. Character_ID and Character, City_ID and City, etc.) I am trying to make a form for inputting data which includes a lookup for each of the 2-field tables plus a text field for "notes" and "page ", but I can't seem to make it work. I made a very complex database with about 30 tables in all sorts of connections using lookups and it works fine. So why can't I make this siimple database work. Please help. I am on a deadline. Thanks, Rob |
Thread Tools | |
Display Modes | |
|
|