Newbie ?: First field changed my data

[Its Just Me]

Hi,

Need some more newbie help, cant seem to locate info or figure this one out on my own.

I currently have 2 tables, I have a portal from table 2, but what is messing me up is the first field from the second table.

I have 4 fields in this portal, for some reason the first field will reproduce the same data in each field.

For example if I enter the following via the portal: (each number will represent data into a separate field)

1 2 3 4 (all is well, until I start to enter more data below if I enter 5 6 7 8…this is what shows up 1 6 7 8.

So what I have is:

1 2 3 4

1 6 7 8

1 9 0 etc.

The first field keeps changing to the very first entry.

The first field keeps auto changing the entry to whatever the very first entry was.

Any suggestions on where I messed up?

I hope I did not muddle this one up too bad to understand.

Thanks,

Jim

Edited July 1, 2006 by Guest

[LaRetta]

Hi Jim,

Look at the relationship name of the portal. Then double-click that first field and make sure it says the exact same relationship as the portal and the other fields.

LaRetta

[Its Just Me]

LaRetta,

Thanks for the information...however, I doubled checked all and all is correct.

I deleted the releationship, deleted the table and rebuilt from the ground up.

It is like there is a ghost global somewhere that keeps changing the first field on every entry to the same name/number or whatever you type into the very first field...the fields to the right all hold their data.

I have looked for a global setting and have found none.

I really have no idea, I was up unitl 3am trying to solve this one.

Again, thanks for the reply,

Jim

[LaRetta]

We could play 10,000 questions or you can post your file.

[Raybaudi]

Hi

is that first field the field that support the relationship ?

[Its Just Me]

Daniele,

Yes you are correct.

Jim

[Raybaudi]

So , whatever you'll enter in that field, FM will change it to the value of the relationship; otherwise it can't be viewed in the portal.

To add real new data with a different ID, you have to make a new record in the related file.

This can be made with a script too.

[Its Just Me]

Thanks for the help, I had everything messed up...took a little while but now all seems well in newbie land.

Thanks again,

Jim