Dennis-
You didn't include prior messages in this reply, so it's tough to remember what went on before. As I recall, the control for Produkt looked like a Text Box, not a Combo Box. That combo box should be setting the Produktnr foreign key in the table you're editing in the subform.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Oct 21, 2014, at 10:39 AM, Dennis Davidsson dennisdavidsson@ymail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
sorry I was unclear i my last mail.
The control named Produkt in my subform is of course a combo-box, in which the fields Produktnr (datatype = auto number) and Produktnamn (datatype=text) and 4 more are read from the table Produkter joined with the table Producenter (the company producing the products in table Produkter) on the primary key Producentnr of this table.
Dennis
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (40) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar