Dear folks
I have a 2 table; first has GroupID, GroupName, second had ItemID, GroupID, ItemName.
Then I build a form with First Table and add subform with Second table.
In the sub form, I want to auto populate all item ItemID, ItemName after choosing a GroupID in main form.
first table: FirstID (primaryKey), GroupID, GroupName ==> will become "main form"
second table: ItemID, GroupID, ItemName ==> will be "subsorm"
FirstID GroupID GroupName 1 1 Big Fruit 2 2 Small Fruit
ItemID GroupID ItemName firstID 1 1 Jack Fruit 1 2 1 Water Melon 1 3 2 Berry 1 4 2 Strawberry 1 5 2 Apple 1 6 2 Banana 1
Your help is much appreciated.
Sai Han