OK Bear with me here, this could get hairy.
I have a form, TheBigForm. On TheBigForm I have a control box called DealerName. This control is tied to the table DealerList. In the table, DealerList, there is a field, DealerGroup. TheBigForm needs to know what the DealerGroup is for each DealerName. This information will be used to determine the BranchID and perform multiple calculations on TheBigForm. I have agonized on how to phrase this question so somebody reading it may know what is going on in my twisted head but I am sure there are more questions that need to be answered before I can be helped. Please just ask. Assistance will be most helpful.
I have a form, TheBigForm. On TheBigForm I have a control box called DealerName. This control is tied to the table DealerList. In the table, DealerList, there is a field, DealerGroup. TheBigForm needs to know what the DealerGroup is for each DealerName. This information will be used to determine the BranchID and perform multiple calculations on TheBigForm. I have agonized on how to phrase this question so somebody reading it may know what is going on in my twisted head but I am sure there are more questions that need to be answered before I can be helped. Please just ask. Assistance will be most helpful.