I would like to show a list of rows from a table with no primary key. The table has a column to use as a foreign key, but I can't make a browse form to show the rows in a subform, as I have no primary key.
An unusual situation I know, but how can I achieve this?
Welcome to the nuBuilder Forums!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Browse a table with no primary key
-
- nuBuilder Team
- Posts: 4562
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 76 times
- Been thanked: 528 times
- Contact:
Re: Browse a table with no primary key
As long as you're not adding new rows, enter any other column as primary key (e.g. the foreign key) and data should be displayed.
-
- nuBuilder Team
- Posts: 4562
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 76 times
- Been thanked: 528 times
- Contact: