I've got a database to track the hardware configurations of the various machines in a lab. each configuration has a config id,then a series of fields for cd, cpu, etc.
What i want to do is create a form with a dropdown of the machine names. Doing so will cause all the other fields to fill in with the correct data.
I'm a newbie here, so please forgive if i'm not explaining clearly. what i've tried is i created a query that pulls the most recent configurations for each machine name out of the database, and made a form based on that. i can make the name field a dropdown, but it doesn't allow me to select, so it doesn't update the other fields.
the goal is to be able to find a machine name on the drop down, see its current configuration, and then if something needs updating, select the new hardware from the dropdown of the appropriate field then save it.
What i want to do is create a form with a dropdown of the machine names. Doing so will cause all the other fields to fill in with the correct data.
I'm a newbie here, so please forgive if i'm not explaining clearly. what i've tried is i created a query that pulls the most recent configurations for each machine name out of the database, and made a form based on that. i can make the name field a dropdown, but it doesn't allow me to select, so it doesn't update the other fields.
the goal is to be able to find a machine name on the drop down, see its current configuration, and then if something needs updating, select the new hardware from the dropdown of the appropriate field then save it.