Learning
Feb 24, 2005Hi everyone . I am very new to the database world . I have been creating a basic "flat table" for a fishing club i belong to . We hold major auctions twice a year and i have been desiging booking in forms to enter in information about the product for auction etc.I have managed to create my table , some queries and reports using access 2000. I have managed to create combo boxes with set parameters . what i need to know is :
1. I have form that has the following fields.
Lot #
Name
Title (combo box containing Mr,Mrs,Miss etc).
Description
Numbr of items ( combo box )
Reserve price
I can enter in values , that is no problem . What i want to know is , if a name or product description ,is already entered into the database how do i set this up so a pull down menus appears with existing values , or if the name or product description is not currently in the table i can enter in the new information. ( i hope you understand what i am saying).
My auction table consists of the following:
ID ( auto generated)
Lot # (number)
Name (text)
Contact number (number)
Description (text)
Number of items (number, combo box)
Reserve price (currency)
Auction Price (currency)
Money paid to seller (currency)
Nett$ (currency)
Invoice (text, combo box "yes or No")
Invoice # (number)
Any help would be much appreciated.
chris :rolleyes: