forms and tables

[cosmicangel01]

hi!!!
i have 2 problems
1. i have 2 tables one is based on software and what type of software each person in the company has on their comp. and the other is the number of licences i have for that type of software
how do i connect the two to tell me how many licences i have left after i enter a record or that i have no licences left when i enter a record
and 2.
when i enter a new type of software in a form how can i make it become a heading in my software table
thanks to anyone that can help

 

[paron]

Your first question sounds troublingly simple! Either you are asking something very, very basic to any programmer-level use of Access, or I have misunderstood the question. I sweat bullets over the tone of this post!! I hope I hit the right tone.

If you are a newbie to dba-level work with Access, you have my sympathy; there is a surprising gap between "Expert User" and "Setter-upper," and not many good ways to bridge that gap. Alison Balter's books were the most helpful tools to me, at first, and then this forum really started to make sense.

So, here's a short answer to keep the posting alive:

Create a relationship between the tables first, if you haven't, where the table "SoftwarePackages" has an ID field with a unique number to identify each sofware package in the table. An autonumber field usually works well for this.

Each record in your "UserLicences" table will refer to only one software packageID. This is a one-to-many relationship.

Then, I would create a query which counts the number of records referring to each softwarepackageID in your "UserPackages" table. Display the results of this query on your form.


-- If the answer sounds condescending: Please rephrase your question, I must have misunderstood what you were asking.

-- If it merely sounds confusing: I suggest working through some on-line tutorials on tables and relationships, and Alison Balter's books.


Finally, on question 2, I would consider faq181-66 as a starting point.


Ron

P.S. I'd be a little more hopeful that I am not wasting my time here if you had marked the post for email notification. As it is, I may never know whether this was at all helpful or not.