Sounds like the field is defined in the wrong table. Do you have a table for customers and a table for orders?
If so, this field needs to be defined in orders, not customers.
I’m pretty sure it’s defined in the newadorder table, but I will check. Thank you.
If you find that's the case, the next step is to describe your layouts where you see this value repeated as there are also other possible causes.
I created the field in a table called “AdsRun”. It was then put in these other fields: AdOrder, AdsRun2, NewAdOrder, and NewAdRun. It shows up in the Account file, although the field itself is not in the Account table.
Does this make sense?
Not really. Are those tables, table occurrences or layouts?
Here's the difference:
In Manage | Database, you define tables on the tables tab. When you define a new table, you also get a new table occurrence and a layout with exactly the same name. Though they have the same name, they are not the same thing.
On the Relationships tab inside manage database, you'll find a series of boxes. Each "box" refers to a specific table--either a table on your tables tab or the table found in another file if you set up an external data source reference to that file. The table occurrence box may have the same name as the table it represents or it may have a completely different name. You can make more boxes (more occurrences) for a given table in order to set up different relationships that link to that same table in different ways.
Each layout then, specifies a particular table occurrence in layout set up in the "show records from" box. That establishes a "Starting point" that determines what data can be displayed on that layout as controlled by the relationships linking that occurrence to other table occurrences.
So are those tables or are they layouts? And if you are talking about layouts, from what table occurrence they were added, the layout's table occurrence and whether you are using a portal are all factors that might result in the same value showing up repeatedly.
If they are tables, then it would appear that you have added this field to tables where they do not need to be added.
I entered the new field, “LiveLink”, in a table called “AdsRun.” Because this table is linked to three other tables (one of which is a second occurrence of the “AdsRun” table), I was able to adjust the layout on those four tables to allow for the “LiveLink.” The “LiveLink” also added itself to two of the other tables, but not the third. It is in the third table that the “LiveLink” data repeats itself in all the order entries.
Because this table is linked to three other tables (one of which is a second occurrence of the “AdsRun” table),
That sentence confuses "table" an item on the tables tab with table occurrences on the relationships tab. Presumably, you are describing table occurrences. And how did you link them in relationships? The nature of each realtionship is a key factor here.
The “LiveLink” also added itself to two of the other tables, but not the third.
That makes no sense. a field cannot "add itself" to anything except maybe the current layout (depends on preference settings) and will certainly not appear in a table. Do you mean the table view on a layout?
it is in the third table that the “LiveLink” data repeats itself in all the order entries.
Again, I think that you mean that you have a table view not an actual table here. And the relationship between that layout's table occurrence and the occurrence of AdsRun from which you added that field to the view is likely what is causing you to see the same value to repeat itself as your relationship might be matching to the same record in the related occurrence of AdsRun for every record on your layout.
Screenshots of your layout where this repeats and a screen shot of the relevant relationships would be helpful.
I’ve added several screen shots here of what I’ve been working on. I think it should be clear what they all are. The account is one that I’ve made up for this purpose.
Thanks for taking a look.
Here's what I can tell from those attached files and images:
You have a number field named LiveLink defined in the AdOrder table.
You have a repeating number field number field named LiveLink with 2 repetitions defined in the AdsRun table.
These are two different fields in two different tables.
Your zipped files are snapshot links. These are not something that I can open without the actual database file so they don't tell me anything.
You did not upload a screen shot of the layout where you see this value repeating. Seeing that layout and knowing which table occurrence is specified for it, might tell me something.
To clarify, these are layouts, not tables. And I see a portal on the Accounts layout with the same amount repeating over and over in the portal.
Is that where you are seeing this value repeat?
On what Table Occurrence is the layout based? In Layout setup, this Table Occurrence will be named in "show Records from". It's probably "accounts", but let's make sure.
We then need to know on what occurrence your portal is based. Open portal setup (go into layout mode and double click the portal) and tell me what name appears in Show Related Records From.
Then, while still in layout mode, select that LiveLink field in the portal row and tell me what Table Occurrence it was selected from. (This will be the text to the left of :: in the "Display Data From" box on the Inspector's data tab.
From the third pic, it looks like the field 'live link' might be sitting too high on your portal.
Knock it down a tiny bit and try again.
It needs to sit entirely within the first row of the portal.
Otherwise continue with the good advice you are getting from philmodjunk.
phil-hanson has a point and this was one of the possible issues I was considering. To test it, try moving the portal a few pixels and see if this field moves with it. If it does not, drag the field away from the portal, Release the mouse button and then drag it back. Be careful not to release the mouse button until the field is fully enclosed in the portal.
Just nudging the field down a few pixels might not fix this issue as the portal has to "contain" or "own" the field object.
But keep in mind that this isn't the only potential issue here.
1. The table occurrence is based in “Accounts”.
2. When I double click on the portal (the livelink box) in layout mode, I get a specify field box; I cannot find a “Show Related Records From” area.
3. Table Occurrence selected from "AdsRun 2 :: LiveLink"