Search results

  1. B

    Tables and relationships

    I'm a novice and I'm confused. Maybe it's the way I think. I feel like there is an easier way that I'm overlooking, but I can't seem to get a satisfactory solution. How would YOU create your tables/relationships if you had the following: * The general purpose is to manage orders * You have to...
  2. B

    Automatically changing cell content (newbie question)

    Okay, I made a quick sample database on what my troubles are. Access 2003. Use the form to enter data. You will see that it automatically sets the finishedDate column based on your start Date. Also it will automatically suggest bananas for monkeys and seeds for birds in the Act / React columns...
  3. B

    Automatically changing cell content (newbie question)

    Sorry. Again, I think it is me who isn't expressing myself good enough. I'm using a form and changing the value of the cell in the main table which points to the Kund table using the primary key number. So by changing the value of that cell to 1, I will point it to Presto, 2 to Vivestra and so...
  4. B

    Automatically changing cell content (newbie question)

    What I'm trying to say is I can change the value of the cell by changing its reference key (number) value but that can lead to trouble in the future. See the picture below. This is the main table. There is a column there named "Kund". It is linked to another table using a number as primary key...
  5. B

    Automatically changing cell content (newbie question)

    They do alot of adding and removing rows of data, and the changes would be mainly out of convencience. An example: They set the start date of a project, and by doing that it automatically calculates the end date, seven days later. But that is not always the case because they need to be able to...
  6. B

    Automatically changing cell content (newbie question)

    I wasn't sure which section this belonged to (tables/forms/visual basic?) so I posted it here. Keep in mind I'm a database and VB novice so please bare with me. I'm trying to create a database based on an Excel document. In the Excel document different entries selected from a dropdownlist will...
Back
Top Bottom