Best way to enter order number.

[alfranco17]

I'm posting this on January 1st, so... Happy New Year!

I have a problem that must have an easy solution, but I'm stuck.

I am trying to create an order entry system.

I have an item table, a family table and an order detail table (I also have the order header, but I don't think it is part of the solution).

I need to use a datasheet view to enter items into the order detail. I created a form, and added a Combo Box to select the family, and then show only the items that belong to that family.

My problem is this: family shows up blank. When I select a family, it gets assigned to the whole datasheet column.

What I am trying to do is to show this in family:

• consonant
• number
• vowel

And then it should let me select the family when appending records.

I tried using the "On current" event, but it always displays the same record on the whole column.

Any help will be appreciated.

Thanks.

 

[Brightspark98]

Hi There,

I am only just beginning with Access so this may not be what you are looking for but try this.

Open your fOrderDet DataSheet in Design View and change the input type to on your Family field to LookUp. From there you will have the choice to lookup values to show in the family Field or alternatively you can enter the selections manually.

Mark