=> Form fields to Save to two Tables

[Rhonda Fischer]

Hello,

I have a datasheet that I will be using to save
data into two of my tables: tblDeliveries and
tblOrders. However there are a couple of fields
that will need to be saved both to tblDeliveries
and tblOrders for example [Date] will need to be
save to both tables. How am I able to do this?

The record source of a text field can only be set
to one column in one table?

Any ideas would be most appreciated.

Thank you kindly
Rhonda

 

[MacDermott]

You might want to reconsider your table design.
Presumably each delivery is associated with an order.
So if you have the date in tblOrders, and tblDeliveries contains a reference
to the order, you don't need to repeat it in tblDeliveries.
In fact, I would think that if you have a DeliveryDate field in
tblDeliveries, it would generally be different from the OrderDate in
tblOrders.
[Note that I'm using more explicit names for the date fields. It's
generally a bad idea to name a field Date, because this is a reserved word
in Access.]

HTH
- Turtle