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
MarkShnier__You
Qrew Legend
Qrew LegendIf you truly have a correct relationship and One Parking Spot can only be attached to a single deal at any one time, then you just need to think backwards.
Run a report of unassigned parking spots and edit or grid edit to attach them to a deal.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Run a report of unassigned parking spots and edit or grid edit to attach them to a deal.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- I guess my disconnect is how to exactly implement that on the deals form....
Create some kind of field or drop-down that uses said report as it's source?
------------------------------
Phil Dupont
------------------------------- MarkShnier__YouIf 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
------------------------------- 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:
- 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
------------------------------
