Posting a form to multiple related tables

Here’s what Im trying to do..
I got a form that adds the info for a retail store for something like a CRM. The data is contained in multiple Xano databases. For example, the store name, address, phone, location, status is all in the store base. The buyer info is stored in a separate database related with buyerID. Same for some other info like store assignments such as sales rep and activation team.
When click on the add store button you have a form where you enter all that stuff which sends it to Xano in an API post.
What I think I need is to post the buyer info in an action before the post Store info and receive back a Xano assigned buyerID which is added to a variable then include that variable in the Post store.
But I cant figure out how to do that.

You need to handle all of this in Xano ideally. Otherwise you risk the integrity of your data.

Yes, thanks. I figured that out after posting this with the help of Calude.ai :slight_smile: I’m workling on setting up the Xano API that handles the whole thing

1 Like