AnsweredAssumed Answered

Table Occurances

Question asked by NanetteHartley on Feb 1, 2012
Latest reply on Feb 1, 2012 by NanetteHartley


Table Occurances


I realize this is probably a dumb question, but let me see if I understand this correctly.


If I have a table called Requesters, and I need to put some of the information from that table onto a record in a table called Requests, do I need a table occurance (TO) for each item I need to have passed between them?  Or do I only need to have a single relationship between Requesters and Requests and then I can pass whatever information I need to?  


Requesters::RequesterFullName --> Requests::RequesterFullName is the relationship I currently have, but I also need to pass information such as their phone number, email address, and department on the form for the request (so we can have a complete record to print for them later).  Do I need a new TO for each item from Requesters to send all that information? I know I can do a lookup, but if I then try to pull that data to report on later, it doesn't seem to work if there is no relationship for the data being queried.