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
------------------------------
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
------------------------------- MarkShnier__YouThe 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
------------------------------