A
Amanda Byrne
on a database for a wildcat sanctuary I have an Animal Records table and an
Animal Species table. The Animal Records table has a species ID field
relating it to the primary key in the Species table. (many:1)
In my Animal Record Entry form, I have a combo box that has the following
properties:
Control Source: [Animal Records].[Species id]
Row Source: Select [species id], [name] from [Animal Species]
Bound Column: 0
Column Widths: 0";1"
Default Value: [Animal Records].[Species id]
When I check the form in Form View, it shows all the Species from the
species table in the drop down box, but the default value seems to always be
one off.
For instance, Elwood is a jaguar (species id=3), but the default value for
his record is kinkajou (species id=4). If I change the dropdown box to
"Jaguar" it updates the Species ID in Animal Records to "2". The IDs listed
in the Species table are correct, The species id in Animal Records is a
Number field, the Species id in Species is AutoNumber. I don't understand
what is causing the problem!
Any suggestions?
Amanda
Animal Species table. The Animal Records table has a species ID field
relating it to the primary key in the Species table. (many:1)
In my Animal Record Entry form, I have a combo box that has the following
properties:
Control Source: [Animal Records].[Species id]
Row Source: Select [species id], [name] from [Animal Species]
Bound Column: 0
Column Widths: 0";1"
Default Value: [Animal Records].[Species id]
When I check the form in Form View, it shows all the Species from the
species table in the drop down box, but the default value seems to always be
one off.
For instance, Elwood is a jaguar (species id=3), but the default value for
his record is kinkajou (species id=4). If I change the dropdown box to
"Jaguar" it updates the Species ID in Animal Records to "2". The IDs listed
in the Species table are correct, The species id in Animal Records is a
Number field, the Species id in Species is AutoNumber. I don't understand
what is causing the problem!
Any suggestions?
Amanda