Hi,
i was searching in net since long to find code for this problem.
I have 2 tables( IDP , Products) in ACCESS Database(Tempo.mdb).
there are more than one product with same ID's. so in this table IDP the field ID should take each ID only once.(i mean No duplicate).how can i do this that this field takes no duplicate numbers.
i have 2 forms with listviews in each ( LST1 and LST2)
when i Open a Form it shows Listview (LST1) with these all ID's without duplicate values. then user selects an ID and presses OPEN button.
Now i want that the LST2 shows all the products having this ID number.
how can i write the code.
thx friends..hope u help me.
i was searching in net since long to find code for this problem.
I have 2 tables( IDP , Products) in ACCESS Database(Tempo.mdb).
there are more than one product with same ID's. so in this table IDP the field ID should take each ID only once.(i mean No duplicate).how can i do this that this field takes no duplicate numbers.
i have 2 forms with listviews in each ( LST1 and LST2)
when i Open a Form it shows Listview (LST1) with these all ID's without duplicate values. then user selects an ID and presses OPEN button.
Now i want that the LST2 shows all the products having this ID number.
how can i write the code.
thx friends..hope u help me.
