I have a db with few tables. 2 main tables and the rest are used to create dropdown menus when adding data. So far all is working very well. The relationships are ok and when I insert data I can see the NAMES stored in the 4 tables.
But when published(with ms access), I only can see the auto_number for each secondary table, not the names stored in it.
--------------------------------------------------
Example:
MAIN TABLE(#1):
ID- autonumber
DATE- date and time
AREA - there are 10 areas, stored in table #2
KIND - kind of date, stored in table #3
TABLE #2
ID_TABLE2 - auto_number
new york
LA
.
.
washington
TABLE #3
ID_KIND - auto_number
sale
rent
--------------------------------------------------
in this situation, when published, I cannot see the names(ny,LA sales,rent) but their correspondent AUTO_NUMBER
The result will look like this:
ID=1
DATE=2/10/00
AREA=2
KIND=2
what I need is area: LA
and kind of entry : rent
Any help would be much appreciated, thanks a lot.
But when published(with ms access), I only can see the auto_number for each secondary table, not the names stored in it.
--------------------------------------------------
Example:
MAIN TABLE(#1):
ID- autonumber
DATE- date and time
AREA - there are 10 areas, stored in table #2
KIND - kind of date, stored in table #3
TABLE #2
ID_TABLE2 - auto_number
new york
LA
.
.
washington
TABLE #3
ID_KIND - auto_number
sale
rent
--------------------------------------------------
in this situation, when published, I cannot see the names(ny,LA sales,rent) but their correspondent AUTO_NUMBER
The result will look like this:
ID=1
DATE=2/10/00
AREA=2
KIND=2
what I need is area: LA
and kind of entry : rent
Any help would be much appreciated, thanks a lot.