SQL Data Entry Tool with foreign key display as dropdown - 06-24-2004 , 09:08 AM
I am about to put together a small DB (based on mysql for the time
being), and now I would like to enter data into the DB via grapphical tool.
By now I have found tons and tons of tools being able to achieve this
(in conjunction with mySQL), but unforuntately I have until now not been
able to detect a tool where the foreign keys from one table to another
can be used for a dropdown help.
This in turn means that one needs to have the other table open and know
which field is the referenced field to enter the right data.
I have found one program really giving this feature, called Brilliant
Database 3.6 Pro, however it comes along with an own DB, and that's not
what I want (as I want to use the same DB that is used for uploading
data to my Webspace provider).
It would be really cool if there would perhaps exist a tool where I
could decide that the referenced field should be stored, but for display
another field (or set of fields) should be used, but if that doesn't
exist I could come along with the first mentioned option.
To make it clear:
Suppose I have a supplier table, with fields ID, First Name, Last Name
and a goods-table with fields ID, supplier, number, amount/good. Now the
supplier field in the goods-table points via a foreign key to the ID in
the supplier table.
Now I would like a tool where I (without writing code) just can assemble
an entry sheet for goods, so that the user for selection of the
supplier just can click the dropdown box and get a list of supplier id's.
As in the Nice Solution, but I can specify (again without writing code)
that the fiel to be stored is the supplier ID, but displayed shall be
the combination Lastname,Firstname from the supplier table.
Hope someone has a good hint for me,
Re: SQL Data Entry Tool with foreign key display as dropdown - 06-25-2004 , 01:46 AM
Thomas Juergensen <Thomas.Juergensen (AT) sap (DOT) com> wrote
It can do both the nice and optimal solutions against whatever backend
system you would like to use.