hi all
i have a very weird database... but... i nned it to do sumthing sooo...
problem;
i want a form to use a combobox then have a few text boxes auto fill the details... i have attempted to use the comboX.columnX command however this fails to work...
what i have is 3 tables,
business details
employee details
car details
1 business can have many employees,
and each employee can have many cars.
i have used a query to gather all this information into 1 place,... THIS IS PROBABLY WHERE IM GOING WRONG?? but if it can be done in another way then so be it...
on a form i want to be able to search for a car reg (this is my primary key in the car details table).
once the car reg is entered i want the employee details to appear, ie, name, address, ect and then also have the business name, address ect appear...
any thoughts would be muchly appreiciated
reagrds
i have a very weird database... but... i nned it to do sumthing sooo...
problem;
i want a form to use a combobox then have a few text boxes auto fill the details... i have attempted to use the comboX.columnX command however this fails to work...
what i have is 3 tables,
business details
employee details
car details
1 business can have many employees,
and each employee can have many cars.
i have used a query to gather all this information into 1 place,... THIS IS PROBABLY WHERE IM GOING WRONG?? but if it can be done in another way then so be it...
on a form i want to be able to search for a car reg (this is my primary key in the car details table).
once the car reg is entered i want the employee details to appear, ie, name, address, ect and then also have the business name, address ect appear...
any thoughts would be muchly appreiciated
reagrds