=> Form fields to Save to two Tables

  • Thread starter Thread starter Rhonda Fischer
  • Start date Start date
R

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
 
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
 
Back
Top