Jump to content
  • 0

Table - Data transfer


cire01
 Share

Question

Example:

I created a registration table, buyer table and a seller table.

I built a registration form, which inputs the register person data in the registration table. In the registration form itself, there is a drop down that allows one to register as a buyer or seller. Based on what a person selects (buyer or seller), I would like their data to transfer to the appropriate table (buyer table or seller table).

Is this possible?

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

No, I don't think it can be done that way. But one option to keep in mind is filtered views. If you kept buyers and sellers in the same table, you could then create a view filtered on that field equal to "Buyer"; and likewise for "Seller". So now you have two views to use as if they were separate tables.

For what it's worth,

Tim

Link to comment
Share on other sites

  • 0
On 12/22/2018 at 9:35 PM, JolliBeng said:

Hi cire01,

I think that can be done using Triggered Actions.

You can create a trigger that will Insert Into Buyer table the data from the registration table if the person selected "Buyer".

 

-JolliBeng

In addition to this, you can just create a field in the registration table that tells if they are seller or buyer then create 2 views, one for each. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...