JoelNoland
Qrew Member
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Add multiple records to form from another table
Okay my tables are as follows Trailers Transfers Transfer Form Transfers is a child to Trailers & Transfer Form I 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. ------------------------------ Joel Noland ------------------------------12Views1like0CommentsAdd multiple records to form from another table
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? ------------------------------ Joel Noland ------------------------------124Views0likes2Comments