S
Shetty
Dear Sir,
My first combo contains 2 comulms
1st column custoemr ID
2nd column customer name & address
My second combo contains again 3 colums
1 st column machine ID
2nd column customer name & address
3rd column machine serial number
At present I am application for amc maitenance software. A customer may have
more that machines, so machine table and customer table are differenet.
Further a AMC collection from a single customer may pertaining to verious
machines related to same customer which are located in its various branches.
So After collection I want to allocate each payment for respective machines.
By default combo1 column2 value will be equal to
combo2 column 2 (Eventhough customer ID(Combo1) & machine ID's (combo2)will
be defferent.
So on got focus of combo2 I want to select customer name & address which is
equal to combo1 column2 text
Or else the user has to type and select machine address as most of the cases
customer address = machine location address
infact I want to select machine ID on the basis of the machine address which
is equal to customer adress
Please advise on the above.
Or let me know if you have any alternative method for handling above issue.
I am basic programmer without much exposure to MS Access.
Both the tanles customer and machine are having one to many relation ships
with customer ID primery key
Thanks
Ramesh Shetty
My first combo contains 2 comulms
1st column custoemr ID
2nd column customer name & address
My second combo contains again 3 colums
1 st column machine ID
2nd column customer name & address
3rd column machine serial number
At present I am application for amc maitenance software. A customer may have
more that machines, so machine table and customer table are differenet.
Further a AMC collection from a single customer may pertaining to verious
machines related to same customer which are located in its various branches.
So After collection I want to allocate each payment for respective machines.
By default combo1 column2 value will be equal to
combo2 column 2 (Eventhough customer ID(Combo1) & machine ID's (combo2)will
be defferent.
So on got focus of combo2 I want to select customer name & address which is
equal to combo1 column2 text
Or else the user has to type and select machine address as most of the cases
customer address = machine location address
infact I want to select machine ID on the basis of the machine address which
is equal to customer adress
Please advise on the above.
Or let me know if you have any alternative method for handling above issue.
I am basic programmer without much exposure to MS Access.
Both the tanles customer and machine are having one to many relation ships
with customer ID primery key
Thanks
Ramesh Shetty