Relationship Issue
I have a heck of a time getting my mind around this relationship, fumbling around every time with it.
In the Parent Table – Resets, I use a text-formula field in the Resets Table to create the Rese...
Forum Discussion
Hans,
It is hard to follow your description. Is this what you are talking about?
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
It is hard to follow your description. Is this what you are talking about?
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Don I believe it is... I do have one question in regards to your diagram... what is the FT after ResetID#?
I'm sorry QB and database design is not my primary responsibility and I know just enough to be dangerous...
------------------------------
Hans Hamm
------------------------------
I'm sorry QB and database design is not my primary responsibility and I know just enough to be dangerous...
------------------------------
Hans Hamm
------------------------------
- Hans,
You will be more dangerous and much more valuable to the company soon.
The FT stands for Formula Text. I always short hand the fields so that I know what is real data and what is meta data that can be changed in moments notice across the entire database.
Since we have the diagram right, I assume you have made the black relationships in the application and it is the one in red that you need. It is very easy to make that with a caveat to follow.
Go to the Travels Table
Click Settings
Click Relationship
Add a Relationship
Travels have many Resets
This is the easy part, now for the caveat. None of the Reset records will be related to a Travels record automatically. It is a brand new field and can be set by a User.
I assume you are really trying to get a Reset record to be related to a specific Travel record?
Do you want the Reset to know the Lead from the very first Travel record?
Do you want to know the Lead from every Travel record?
Assume there are 25 Travel records for a single Reset. The Employee on each Travel Record is different. Which Employee do you want the Reset to know? In the Reset record you can put a report now that will show all the Travel Records and the Lead/Employee.
There may be a better way to do this if you are trying to accomplish something else.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------- Don,
I think this is where I am not getting this with QB.
When I go into a specific Reset, I have an embedded report Travels which lists those associates who are working and I can add the field Reset Lead and it provides the name that I am looking for.
But, if I want to create a report in Resets that will provide me the Reset Lead name
------------------------------
Hans Hamm
------------------------------- Hans,
Send me your number. I think I know the issue, lets do a quick call.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------