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, 200619 yr by Guest

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

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

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

Hi

is that first field the field that support the relationship ?

Daniele,

Yes you are correct.

Jim

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.

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

Thanks again,

Jim