How to add a record to my join table
I have a many to many relationship between Patients and Labs. I have two questions: 1. How do I add a record to the join table (Patient-Lab) directly (and allow the user to choose which Patient ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTypically, you would add a Patient Lab Join record by launching off a Patient or a Lab Record. If you launch off a patient record than the field for related patients should fill in automatically so you would just need to choose the lab. And vice versa if you launch off a lab record then you would just need to choose a patient but you probably don't work out in that direction.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
The best practice is to have a field on the patient record called patient identification although in your case it could simply be patient full name, and similarly on the lab record to have a field for the lab identification. You may need to build a formula field to make these identification records.
Then on each relationship you look up those identification fields and set the field for [Related Patient] to be that have a Proxy of that [patient identification] field.
Just be sure that the patient identification field and the lab identification field are on the form for that patient lab join record.
Just be sure that the patient identification field and the lab identification field are on the form for that patient lab join record.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- I completely understand, Mark. Thanks for the assist. Let's just focus on the #1 case. If we solve that, it will be good enough for a while.
Here is the relationship/field structure in both directions.
When I view a Patient record, all of this data populates properly.
However, when I try to add a patient lab by clicking on the "Add Patient Lab" in the Patients table, this is what I get:
Notice that Patient Primary Key is blank, despite this being clicked from the Patient record directly.
Here is the URL formula for the Add Patient Lab:
URLRoot() & "db/" & [_DBID_PATIENT_LABS] & "?a=API_GenAddRecordForm&_fid_26=" & URLEncode ([Patients Primary Key])& "&z=" & Rurl()
Also, notice the Lab Primary Key is a read-only field. How do I create a lookup where the user can select from all Possible Labs which one they want? Normally I would think this would be done by a record picker, but it's almost like the URL for adding a Patient Lab isn't populating properly.
------------------------------
Solace Sonder
------------------------------- MarkShnier__YouI agree that something is seriously messed up on that form behavior. Can you show me a screen shot of the form setup for the field Patient Primary Key on the Patient Labs form? ie customize this form and then highlight that field and take a screen shot?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Yes. I've tried a bunch of different configurations on this field. :(
------------------------------
Solace Sonder
------------------------------
