Drop down menu problem

[Learner1]

Hi,

I want the user to be able to select records from a table through a drop down menu.So I have created the recrds in the table and created the drop down menu that shows the items but the problem is that when I select the item it creates a new entry of it. for exemple if I select "client", it creates a new entry with client as a type and a new serial number. Does anyone have an idea about what makes this happen?

Thanks in advance

[bcooney]

We need way more info than you've provided to give you an accurate answer.

Tell me, what tables do you have in your system. Are they related, and how?

What is your goal? For example, "On a new invoice, I want my users to be able to pick the customer from a popup menu of choices."

[Learner1]

Hi bcooney,

I am doing a risk management system. I need the user to be able to select a consquence for a given risk. So I have a table for risk and another one for consequences and a join table.As I said I have filled in the table for consequences but whenever I select a consequence for a new risk (for example: consequence on reputation)another record for consequence on reputation is created. I also have the same problem with a check box menu for a nother relationship.

Edited July 24, 2007 by Guest

[Learner1]

Hi,

Any help please? I'm realy blocked here :)