J
jnp834
I am fairly new to vb coding fo Access so forgive me if this seems
obvious.
How do I create a form to allow the user to enter new data thereby
creating a new record, that needs to be inserted into the table along
with IDs from its two "parent" tables?
To be more specific...
I have 3 relevant tables in my system:
Land Table - Land ID is PK
Resources Table - Resource ID is PK (Land ID is FK)
Resource Value Table - Value ID is PK (Land ID and Resource ID are
FKs)
I need to allow the user to enter multiple records into Resource Value
table, for any given Resource for each Land Parcel. So I need to let
the user input 1) Land Id/Name and 2) the Resource ID this new
Resource Value record is related to (since the Resource Value record
needs to store the affiliated Land ID and Resource ID).
Can someone please give me guidance on this...
Thanks
obvious.
How do I create a form to allow the user to enter new data thereby
creating a new record, that needs to be inserted into the table along
with IDs from its two "parent" tables?
To be more specific...
I have 3 relevant tables in my system:
Land Table - Land ID is PK
Resources Table - Resource ID is PK (Land ID is FK)
Resource Value Table - Value ID is PK (Land ID and Resource ID are
FKs)
I need to allow the user to enter multiple records into Resource Value
table, for any given Resource for each Land Parcel. So I need to let
the user input 1) Land Id/Name and 2) the Resource ID this new
Resource Value record is related to (since the Resource Value record
needs to store the affiliated Land ID and Resource ID).
Can someone please give me guidance on this...
Thanks