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.