You should have that Project information stored in the Project table and then related it to the other tables be a ProjectID key field.
Then when on a layout based off the other tables, one could reference the related parent Project table info.
I tried to do this and it says <unrelated table>
I tried to go and create the relationship within the database but still no luck!
I am a very logical thinker... Is there anyway to write the steps down with examples like:
Table A (Project ID)
Table B (Project FK)
Create connection in relationship tab in managing database
Go to layout.. Open layout options...and so on and so forth
I really am stuck on this and i cant find the answer on the internet anywhere and this seems relatively simple which is very frusterating
If anyone can offer me help over the phone that would be great!
I can exchange my company phone # to who ever can help
Please contact me via private message (top of this page - right side - envelope icon).
I would probably ask others to contact you via private message. You dont need SPAM bots scanning your email address.
Check your private messages ( upper right hand corner, looks like an envelope )
I think that you need to specify how these other tables interact with the Projects table.
All the fields are the same for everytable except the project table containing the information to be copied to the other fields that will be located in the header.
Project Information- I want to type in the Project Name and Number, Etc. one time at the start of the project in the fields under this table.
Architectural- Then have the information i typed in the Project information table fields (Project Name and Nuimber etc.) to appear in the Project Name and Number field within the Architectural Table in the header of the layout.
Electrical - ""
I type the info in The Project Information Table Under the field "Project Name"
Then in the Architectural Table under the field "Project Name" i want it to contains the same data in the Project Information tables field Project name.
SO i dont have to type the Project Name in every table under the Project Name field. That would take up to much time.
Does this make sense?
It seems so easy yet so complex!
You havent really answered the question. I understand what you are expecting. What is needed is information on the other tables. What info they contain and how those other tables are related to the Projects table. I think you may have a structural issue.
All of the other tables are identical... The only thing different is the data inside them.
Architectural has Architectural data and Structural has structural data and so on....
They are not related to the Project Info Table
I tried to connect the ID with the FK then just drop in the field and it still says <unrelated table>
or ::Project Name
But it never imputs the data from the field to the others'
Should i be using the Global Field option>?
I figured out the problem
The Resolution was "the cartesian X"
I had my relationships set to the default of =
But since i wanted all the fields to equal all other fields the cartesian X was the answer.
Thanks for your help.
I got the answer from one of the www.lynda.com tutorials.
If they are not related what project info are you putting on the header??
Well if you have more than 1 project then what? A cartesian will only return the first related project record.
They are related but i have not Connected the relationship until now...
Its hard to type what you try to say some times... the context and syntax is hard to spit out sometimes.
But i havee figured out the problem..
This database is saved as a template then whenever i have a new project i Save as and save it as the project number leaving the Template untouched until the next project