mindpeace
06-10-2006, 12:46 AM
Dear all ,
I very new to access ..hope u will help me ?.
I have created database of transactions ?.each transaction is belong to some person who is member of certain group ?so I have made reference table for that combination and given combination ID ?.
Id person groups
1 A AA
2 B BB
3 A BB
4 B AA
so the id that is number is mention in transaction table?
Date ID Transaction
5th may 1 456
6th may 1 464
5th may 2 67
for data entry I want to create an form with dependant cascading combo boxes of person and group and I want that every transaction should pick up ID based on those combinations ..
please help me to solve this
I very new to access ..hope u will help me ?.
I have created database of transactions ?.each transaction is belong to some person who is member of certain group ?so I have made reference table for that combination and given combination ID ?.
Id person groups
1 A AA
2 B BB
3 A BB
4 B AA
so the id that is number is mention in transaction table?
Date ID Transaction
5th may 1 456
6th may 1 464
5th may 2 67
for data entry I want to create an form with dependant cascading combo boxes of person and group and I want that every transaction should pick up ID based on those combinations ..
please help me to solve this