Data From 2 Tables

[darno]

I have a query, Which is still un-answered, most probably i dont know how to ask, forgive me if u find it stupid.

My query is about getting data from 2 tables and showing it on a form, there are 2 tables, DETAILS, and MASTER. both the tables have 3 same fields, i.e., CODE NO, DESCRIPTION, PARTNO.

The DETAILS form contains other fields other than above mentioned 3 fields. My query is that when somebody opens DETAILS form and enters a code no in CODE NO field, that time it should check in the MASTER table if the same code no exist. if it does then the other 2 fields (DESCRIPTION AND PARTNO) on DETAILS form should be filled in automatically and saved in DETAILS table.

Sorry again if you did not like it.


Best Regards,


Darno

 

[MStef]

Hello darno!
1) You don't need the same data in two tables,
only if they are the part of foreign key.

2) i suggest you to make a MAIN FORM (on Master table),
and a SUB FORM (on Details table).

 

[darno]

Thanks Bro,

I much appreciate your kind help and the courage to believe that there is someone out there who listens. Thanks again,

Warm Regards,

Darno