Skip to main content
Question

One To One Relations (i.e. Subclasses)

  • June 25, 2020
  • 0 replies
  • 93 views

Hello everyone,
I'm trying to develop an app in QB and am facing a quite odd problem. I cannot find a way to create a one-to-one relationship between two tables.
I've only found this: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=94d0a927-d358-4d8d-bb0a-ce11d273cb8c&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804 on one-to-one, but it is not what I'm trying to accomplish unfortunately.

I'm used to develop in python and Django, so for simplicity let's say I'm trying to develop this usecase:
https://docs.djangoproject.com/en/3.0/topics/db/examples/one_to_one/

In Django I'm able to use the "admin" app and easily embed the fields from the generic table (Place) into the form for creating a specific record (Restaurant), the linked generic record is automatically created on save with the information entered in the fields in the form, so the user does not have to:
- start creating a restaurant
- switch to create a place
- link the restaurant to the newly created place
- finish creating a restaurant
Instead the user should be able to create everything in one single step.

In my app now I have the Restaurant as a child of the Place, but cannot find any way to achieve this sort of "create a record of a subclass".

What would it be the easiest way to do it in Quickbase? 

Thanks and apologies if I missed something obvious...

------------------------------
Francesco
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
If you truly have a one to one relationship, it begs the question as to why bother. Why not just have one table with all the fields on one table. 

But if you like you can set up an Automation to trigger on Creating a Place, to create a child Restaurant. Linked to the Parent Place. 


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------