Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Browse a table with no primary key

Questions related to using nuBuilder Forte.
Post Reply
vario
Posts: 148
Joined: Mon Dec 05, 2011 12:23 pm
Location: Newton Abbot, UK
Has thanked: 1 time
Been thanked: 1 time

Browse a table with no primary key

Unread post by vario »

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?
kev1n
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

Unread post by kev1n »

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.
kev1n
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

Unread post by kev1n »

Is this solved or do you still need our support?
Post Reply