I double checked, it is the Traveler form i want the button on Not the Job form.I can know the identity of the job through the Traveler, it has a field 'Job #' that contains the ID of the Job this traveler belongs to.
Currently i have a button 'Add traveler Detail' on the traveler form. This is the formula for the button
URLRoot() & "db/" & [_DBID_TRAVELER_DETAILS] & "?a=API_GenAddRecordForm&_fid_7=" & URLEncode ([Record ID#])& "&z=" & Rurl()
Normally when the user is on the Traveler Detail form one of the fields is a select box that populates based off of the 'Job Details' table, this select box only shows Job Detail records that dont have a corresponding Traveler Detail Record. (This was setup before the client started using my company for IT, I'm not sure how that works, still reading quickbase docs). When the user makes a selection it auto fill's the rest of the form and saves it. This works well for single job details but some jobs have 50+ details and manually doing this for each one has been a pain for them.
All i really want is a button that will automate the task of
- click add traveler detail - this opens the traveler detail form
- select any entry from the select box
- save
- repeat if the select box is empty(All details have been added) stop
Thank you so much for trying to help
