" Just like a normal table in excel/word etc."
How about, normal as in normalized data, a normal FILEMAKER data structure.
Numbered fields like Traffic1, Traffic2, etc are direct indicators that your data structure is wrong.
Each 'line' should in fact be a line, or more precisely, a record, in a related table.
Yep, bad use of language, but I couldn't think how to explain the issue any other way.
Anyway, I'm still not sure how to build this. All I'm being told is its wrong but noone seems to want to guide me through the problem.
If you want anyone to be able to look at the file you uploaded you had better supply the user name and password.
I suggest you grab a copy of the FileMaker Training Series (Advanced) and work through Module 3 (Data Modeling).
Short version: You need a separate table where each record is a line in the "table" you want to create. Then you use a portal to display the related records from the parent table so that users can enter / edit / create the line items.
(Note: Italicized words are important terms to learn in FileMaker.)
Keywords: I wondered that too, but tried the ever popular admin/admin
Having, with Bruce's help, opened up your demo file I give a big "here here" to Mike's advice. You already have a right mess that needs to be unravelled. Specifically:
1. You have many tables but no obvious (to me anyway) clarity as to whether they reflect a logic to the DB structure.
2. All except one of your tables have no unique ID field to be used as a match field (ref relational databases 101)
3. The few relationships you have created use data fields, not ID fields, and that way leads to problems
My best advice: back to square one! And that means switching off your computer and getting to work with a pen and paper.