Search results

Hi, I have three tables: Table A, Table B and Table C Fields of Table A: Truck No, Capacity Fields of Table B: Consignee ID, Capacity A, Capacity B and Capacity C Fields of Table C: Consignee ID, Final Rate Input form is based on Table C: 1-I select Truck No using a combo...

Thank you so much.Hats Off! for your prompt help. I cant explain my feelings. Thanks

Noted! I have changed the name of the field in first main table: Now: I have a table called main with fields of: Consignee ID, Zone Location I have 2nd table (Consignees) with 2 fields : Consignee ID and Location Now on form I have fields for Consignee ID, Zone Location and one unbound text...

I have a table called main with fields of: Consignee ID, Location One query based on table main. One form based on query. I have 2nd table Consignees with 2 fields (Consignee ID and Location) On Only form I have fields for Consignee ID, Location and one unbound text box. I am retrieving location...

Bro i am retrieving data from 2nd table using dlookup function in (lookup control) and storage field is a simple field from my 1st table. As you suggested. me.newstoragefield = me.lookupcontrol Its not working. Please help me. I cant explain my disappointments. Thanks

I have a form based on query. On form i am retrieving data from another table using DLookup in a unbound text box. So i want to save the result of DLookup function in another field/table on same form. Plase take out me from this problem. Thanks