New to QB and this seems like it should be an extremely simple task.
Simplified, i've got a Trailers table and a Move Request Form table. On the move request form I need the ability to add multiple trailers instead of creating a move request for each trailer individually. I'm not interested in Grid Edit as that will remove any data validation ( I want the user to search for and select the trailer so that I can use this data for automations elsewhere). I've tried using multiple choice from the list of trailers, but without a search bar it's pretty useless for 2k+ trailers.
Why is this so complicated?
Okay my tables are as follows
Transfer FormTransfers is a child to Trailers & Transfer FormI also created a "transfer record #" field on the transfer form table that "transfers" uses as a lookup so that I can display the related "transfer records" on the transfer form. I really need to rename these to something less confusing.
So now on the transfer form I type in some basic info & a transfer record number, hit "add transfer", select a trailer in a new window and once I hit save in that window I can see the list of records with that transfer record #.
I'm good with this, thanks for the guidance.