Forms problem...

Hi people,

I have the following situation - three tables:

TrOrders( TrOrder_id, troDate, troAgency, troTotalPages...)
one-to-many relation with
OrderedTranslations(Ordered_id, ot_tr_id, ot_trName, orAgency, orStatus....)
one-to-one relation with
Translations (Tr_id, trName, trPages, .....)

I receive the Translation table with data ( with periodic updates)
OrderedTransaltions is empy table (so far).

I'd like, when creating new order, to be able to fill the requierd fields in
the TrOrders table and in the same field to chose some documents that will go
on translation (it would be nice if I can write these one by one, because of
the huge number of documents). The documents that I choose here should appear
in the OrderedTranslations table, and at the same time, their status would
change in something else and the field toTotalPages will show the sum of
trPages of all selected documents. Nothing will change in the Translation
table.

Thank you very much,
Viktor Kralevski

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200609/1