Losing functionality on the FE after splitting

[juanfpdm]

Hi all!!

I've developing a little Project and have some issues after splitting a db.

I have some forms in wich I want to see some tables with the "+" sign on the rows so I can go to their linked tables. The problem that I have is that everything works perfect until I split the access file.

:banghead:

Anybody know hoe to help??

Thx!!!!!!!

 

[CJ_London]

Check your relationships in the front end. If you had your tables in the front end then moved them to the back end and created new linked tables, these 'new' tables need their relationships creating

 

[juanfpdm]

Hello CJ,

thanks for your answer, I'had already checked the relationships and they were there, but not all of them were there.

when I ask Access to "show all relationships" there are some that appear with an error that the value is not found, and it shows the relationship to a new table with only one value and the name of the table is like: f_xxxx_"table"

Those missing relationships are not the ones that should appear on clicking the "+" button.

:banghead: :banghead:

 

[RainLover]

Those links could still require a refresh.

 

[juanfpdm]

Hi all,

thanks for your collaboration, I think I found the answer, when splitting the db, I don't know why, some tables had as subdatasheet property "automatic" and some others had the correct value, by changing this field in every table with relationships everything started working properly.

I hope this helps anybody with the same problem!!

 

[RainLover]

Thanks for the update.