How do I get the combo box to link with costs field in the table?
in [Form]
|
Prev: Access frontend with SQL Server backend: my solution for ODBC Call error
Next: Access frontend with SQL Server backend: my solution for ODBCCall error
From: Samiullah on 7 May 2010 08:05 I have a database which I am trying to figure out. I have a field in the table which is the names of the cars and there is a price field. How do I link both of them up so that when I create a form and select the different car the different prices can appear. Can someone offer some help with this Please!
From: Al Campagna on 7 May 2010 09:20
Samiullah, We can't help until we know how you have your table set up. Is the CarName and the CarPrice in the same table? If they are in different tables, do you have a unique key field in each table that "relates" the CarName in one table with a CarPrice in another? I'll assume both fields are in the same table. I'll also assume that when you say "I select a CarName" you mean via a Combobox or Listbox. Is this correct so far? -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Samiullah" <Samiullah(a)discussions.microsoft.com> wrote in message news:A309768B-BE20-4AE5-A331-E7B2C4AEFB9C(a)microsoft.com... >I have a database which I am trying to figure out. I have a field in the > table which is the names of the cars and there is a price field. How do I > link both of them up so that when I create a form and select the different > car the different prices can appear. > > Can someone offer some help with this Please! |