Have one field depend on another field

[TboneSuarez]

Hi.  It's my first day. I'm trying to create a maintenance log for my laundromat. I created a base with the following tables: Washers, Dryers, Maintenance Requests.  The Maintenance Request table is populated by a form I created for my staff to request maintenance. On it I created a field called 'Machine Type' where you select washer or dryer. The next field is 'Machine ID' and if you select washer under 'Machine Type' I'd like it to give a drop down menu showing the Machine ID's from the 'Washers' table and if you select 'Dryer' I'd like it to pull the machine ID's from the 'Dryers' table.  Can I do this?

[Ron_Daniel]

@TboneSuarez 
There are quite a few ways to accomplish your goal. This is my recommendation:

- Combine the Washers table and Dryers tables into one Machines table (instead of 2 tables, it's just 1)
- In the Machines table, have a selection for whether the item is a washer or dryer
- For the name of the machine records, write a formula to concatenate the name. Example: "CONCATENATE({Machine Type} & " - " & {Machine ID})

This way, when they fill out the form, they will see a list of all washers & dryers with IDs to select from.