I’m working with my IT team who is trying to build some SQL views for me for various calculations on data - many of these work great but we ran into an issue with one.
I have a table that is simply a list of our evac centers (name, address, capacity, status).
The list is used in a registration table with a valid if statement that only shows the evac centers with a status of “open”.
all works great.
In the view, IT wants to link the two tables based on an ID number for the evac center so we added an ECID column to both tables.
I created a ref from the reg table to the evac list table but I can’t get the ECID number to record in the reg table when someone completes the registration form.
Do I need a ref field to do this?
Is there a better way to record the evac centers ID number to the reg table when someone registers?