I am the only person with admin priviledges on my database and have not made any changes to schema. All of a sudden I seem to have a broken relation ship. I have a Merchandise table linked to a shipments table. Shipments has an Auto-enter serial number in the field IDShip. I will place that value in a field (also IDShip) in Merchandise. One Shipment to many pieces of Merchandise.

So, I can see if and when an item has been returned to my client by putting Shipments::DateShip in my list of merchandise. Now all of a sudden, rather than a date, I see

If tried removing and replacing the link, creating another instace of the table and linking via that? No joy.

Any ideas?

All of a sudden I seem to have a broken relation ship.

Well no, if you have a broken relationship, the field would change to . And if you had a good relationship but bad connection, it would display .

Place your Shipments::ShipID on the Merchandise layout as well. Does it show? If it shows then something is wrong only with the date field and not the relationship so double-click the date field (while in layout mode) which brings up the Field/Control setup and try re-specifying it to your Shipments::DateShip. If that doesn't work then go to your Manage Database (Table Tab) and check the Shipments date field directly.

Even if you had incorrectly changed either the layout or the table occurrence to a different one, you would be receiving .

If you are still stuck, I would next suggest attaching your zipped file for us to check for you. :wink2:

Edited November 30, 200817 yr by Guest
Added sentence on index missing

I'm not sure I should have Shipments::IDShip on the merch layout?? Isn't it that VALUE, placed in the field Merchandise::IDShip that links the merch to the shipment?

I added the value Shipment::IDShip to the Merch layout and get a and when I respecify the field Shipments::ShipDate, I get the same thing.

I've gone to the Database management, Fields tab and the fields seems OK.

I have this hosted remotely. I downloaded a copy and it works just fine locally??? Possible?? I have yet to be able to upload the database to try it again. It has lots of thumbnail photos and is about 185MB

Have you tried closing your file and reopening it? Sometimes FM can lose connection and, it will display and sometimes but it can find the files again if re-opened.

BTW, I was suggesting placing the ShipID on the layout only for test purposes since this field would ALWAYS have a value. In your external data sources, are you pointing to the served IP address or to the name, ie, DCR-MS-DC-01 etc.

If it works in stand-alone then it isn't your file nor relationships - it is the connection to the served files.

Yeah, I think I'll have to take this up with my hosting Company tomorrow AM. I just downloaded the file...again. It works just like it has for years when I run it locally, but it has this wierdness when I open it from their site.