Re: serial numbers

Kiel Industries (Morwell) wrote:
How to go about this:

Have 6 items, call them item A, B, C etc.
I want to put these items in a drop-down (box) field were users select the item on input, say item "A" needs to be added to the database. But I also need to have item 'A' linked to a serial number field.
Sofar so good, the thing I would like to do now is, that when the user selects item 'B' or 'C' I need it to pick up a different serial number.

Item 'A' = serial number A100, A101 etc.
Item 'B' = serial number B40, B41 etc.

The other thing also is that on creation of a new record these serial number values do not increase automatically but only for the value linked to the Item selection.


Hope someone can give me some info or sample on how to go about this and hope explanation is not all that confusing.

Thanks in advance,
Paul





I assume you have two tables, one for selected/added to order... items, and one for unique items

Your Item dropbox field: select the (text) item, use a second field Item_SN to lookup the item serial number from the table containing the unique items. This way the SN is 'hard' coded into the record. The relationship for this lookup will be itemname::itemname


2 tables right?

regards

Chris Brown
University of Adelaide
.

Relevant Pages

  • Wire up a ComboBox.
    ... How do I wire up ComboBox to my data table to store my selection and to my lookup table that allows me to make that selection: ... DataBindings configuration properties of the ComboBox ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: lookup databinding combobox using stored procedures
    ... data table or something of that nature, and then bind the drop down list to ... table that has its own ID field, the ID field from the lookup table, and ... DELETE commands have been set to the stored procedures and I can call them ... OtherDataTable the combo box must display the appropreate selection. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Lookup Table Field Retrieval / Separating Databases
    ... lookup tables are essential to a smoothly-running ... wish for the user to enter general Physical and Performance data such as ... I cannot understand why the actual selection in the combo box ... clients, and I want to keep the data for each client completely separate. ...
    (microsoft.public.access.gettingstarted)
  • Re: Please Help...Using the column function within a query field
    ... tables (ProjEng in the Projects table -- and the same names in the AssignedTo ... misdesigned, misleading, and all but useless Lookup Wizard misfeature. ... all of the drop down lists (on the Projects Form) work fine (pulling ... updating the selection back to the Projects Table according to the selection. ...
    (microsoft.public.access.queries)
  • RE: detemining values in a range
    ... new sheet that contains only the unique items frm that selection... ... Set rngToSearch = Intersect(ActiveSheet.UsedRange, Selection) ...
    (microsoft.public.excel.misc)