Relationships & Entry Request for Assistance
I'm struggling to accomplish something that I expected to be somewhat simple, but I can't seem to figure out on my own. I have a table of "Deals" that I am trying to associate with another table of...
Forum Discussion
If you want to throw the user into grid edit and return the user to Deal On save, you can try this as a formula URL button on the deal.
URLRoot() & "db/" & [_DBID_table-Name_of parking_spots] & "?a=q&qid=99" & "&dlta=mog&navBack=true";
// change the 99 to the report ID of a regular table report for unassigned spaces.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
URLRoot() & "db/" & [_DBID_table-Name_of parking_spots] & "?a=q&qid=99" & "&dlta=mog&navBack=true";
// change the 99 to the report ID of a regular table report for unassigned spaces.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Hrm, this didn't quite work... probably something I'm not doing right. It does kick me over to a grid report... but there isn't a way to select the records except by editing the individual spaces one at a time.
Is it possible to either:
------------------------------
Phil Dupont
------------------------------
Is it possible to either:
- Click the 'add spaces' button, kick over to a report with a list of unassigned spaces... select a space from the list, save and return to the deal... or
- Click the 'add spaces' button, kick over to the report, check 1 to 4 spaces, save and return to the deal.
------------------------------
Phil Dupont
------------------------------
- The method I suggested assumed that you would use Grid Edit to select the deal but I do acknowledge that this requires the user to remember what deal they launched off of.
Both of the options you requested are possible to do but they are a little too complicated to explain how to do on this forum. I would need to work with you one on one to get those working. Contact me directly by email in my signature line if you want to take this discussion outside the community forum.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
