I am trying to create a button that my Sales reps can click from the "Opportunities" table in our sales app that will direct them right to the "Add Quote" form in our project management app and relate the new quote to the opportunity. I know how to do this within the same app, but can't figure out how to do this across different (but related) applications. Here is what I have so far, but keep getting an error saying the DBID_QUOTES is not a field in the Opportunities table:
URLRoot() & "db/" & [_DBID_QUOTES] //name of the "child" table in project mgmt app
& "?act=API_GenAddRecordForm&_fid_69=" & URLEncode ([Record ID#]) // connecting the child to its parent...here [Record ID#] is the key in parent (Opportunities) and _fid_69 is the related parent in the child (Quotes)
& "&_fid_48=" & URLEncode([Related Client]) //parent field I want to copy into the new child record
Any help is appreciated!