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!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Browse a table with no primary key
-
- nuBuilder Team
- Posts: 4294
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 444 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: 4294
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 444 times
- Contact: