Multi-step form issue

Similar question to one I've asked before but through a slightly different lens this time.

Tables

  • Visitor - Visitor ID - a person, super simple
  • Visit - Visitor ID and Visit ID - pretty simple table with visitor ID and a check in timestamp (really I don't need this in the workflow, auotmatically creating one would be fine too, but have to capture the Visit ID for use in the next step) Multiple visits possible over time, but not as a part of this process, here I'm just trying to add one visit and its services
  • Visit Services - Visit ID and Service ID - pretty simple with a timestamp and status code, multiple entries possible per Visit 
  • Services - lookup table of available services with a Service ID

Here's the workflow/UX path I would like to use.

  1. Create a Visitor using a form (which I have already)
  2. On save, redirect to Visit form to check the visitor in for today, using the newly created Visitor ID
  3. On save, redirect to a Visit Services form

I'm finding that the Visit Services form doesn't like having a Ref to two tables with the IsAPartOf = true so it's not working as I expect (or I just don't undertstand it quite right).

A single form (or multi step form as described here) seems like a decent idea, but I have a 1:M relationship and it's just not clicking for me.  Any ideas appreciated!

Solved Solved
0 2 244
1 ACCEPTED SOLUTION

I ended up taking this general approach and it doesn't flow quite as nicely as I'd like (yet) but I think I have gotten the correct relationships and such.  Thanks for the input!

View solution in original post

2 REPLIES 2

Sounds to me like Visit Services would only be partOf a Visit record. Why would you have 2 ispartof Refs?

I ended up taking this general approach and it doesn't flow quite as nicely as I'd like (yet) but I think I have gotten the correct relationships and such.  Thanks for the input!

Top Labels in this Space