Thread Details
  • State Not Answered
  • Replies 3 replies
  • Subscribers 368 subscribers
  • Views 1628 views
  • Users 0 members are here
Forum Actions

What table can show me a relate field?

Juan Felipe Zuluaga Gómez

Hi people.

I wanna update some registers with a bad id in a relate field, the problem is, where (what table) can I see this relation on BD? for example, I have a relate field between Products and Sellers, in the field Product->Seller, I have the id of the seller. Some register is bad created, I wanna update these registers.

This field isn't a relationship between modules, is just a "relate" field.

Greetings.

Parents
  • 0

    Some system table relates (such as Users) show up a little differently. This also works nicely.

    SELECT custom_module AS database_table_of_custom_module, ext3 AS database_field_name, ext2 AS related_which_module
    FROM fields_meta_data
    WHERE NAME LIKE '<your_file_name_in_studio>'

Reply
  • 0

    Some system table relates (such as Users) show up a little differently. This also works nicely.

    SELECT custom_module AS database_table_of_custom_module, ext3 AS database_field_name, ext2 AS related_which_module
    FROM fields_meta_data
    WHERE NAME LIKE '<your_file_name_in_studio>'

Children
No Data