Jump to content
  • 0

Use Table Multiple Times In View


kfeeney16
 Share

Question

This might have to be a change in my setup, but basic question is can I use a table more than once in the same view?

 

I have two tables I'm discussing in a sales environment:  Agent and PaySetup.  Agent table is basic agent info with an AgentID.  The PaySetup table looks like this:

 

SaleAgentID - the Agent ID of who made the sale

PaidAgentID - the Agent ID of who gets paid when this agent makes a sale (this would be the agent him/herself and any managers, different record for each)

PayAmount - how much the PaidAgent gets

 

So the Agent table would be linked to this table twice normally, but I can't seem to get that to work in Caspio.  I guess I could set up a 2nd table which would just be PaidAgents and be 1 to 1 to the Agent table?

 

Anything I'm missing?  Thanks for any help.

 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

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...