J
Joe Rubalcava
How does one go about creating a form for a linked table
without creating new records in the associated tables.
example. - I want to create a form, that allows me to
select a customer and a shipper and create an order. The
order table has a one-to-many relationship with both
customer and shipper. I would like to use a pull down to
select the approriate customer and shipper and then enter
in the specific order information. By selecting the
appropriate customer and shipper, the query should return
back the appropriate info (addresses, contact info etc).
The problem I am running into is that when I select a
customer or shipper in my form, it is creating another
record for customer and shipper in their respective
tables.
Any and all help would be very much appreceated.
without creating new records in the associated tables.
example. - I want to create a form, that allows me to
select a customer and a shipper and create an order. The
order table has a one-to-many relationship with both
customer and shipper. I would like to use a pull down to
select the approriate customer and shipper and then enter
in the specific order information. By selecting the
appropriate customer and shipper, the query should return
back the appropriate info (addresses, contact info etc).
The problem I am running into is that when I select a
customer or shipper in my form, it is creating another
record for customer and shipper in their respective
tables.
Any and all help would be very much appreceated.