Creating a form for stock management

[StevenStip]

Hello,



In order to create a stock database and make it easy to register mutations in the database.
A mutation is a change in stocks and I want to make it possible to enter a lot of changes at once. There is a mutation table and a mutationlines table that has a relation with articles. In the form I want to show all available articles (about 65) followed by a textfield where I can enter the amount of articles affected.
The problem is that I don't know how to pull all articles from the articles table to use in the form.

Is this even possible?

Thanks in advance,

[June7]

What do you mean by 'pull all articles'? You want a list for users to select from? Use a combobox.

Also, review http://allenbrowne.com/AppInventory.html

[StevenStip]

What do you mean by 'pull all articles'? You want a list for users to select from? Use a combobox.

Also, review http://allenbrowne.com/AppInventory.html

I'd like to iterate trough all articles the database knows and put them as labels on a form followed by an inputfield (textfield) that contains the number of items of this article affected by the mutation. A mutation can be a delivery of 25 articles and different amounts for example.

It should look like this:
===================
mutation: 5 type: delivery
Location: Main warehouse
------------------------
usb cable: 130
sata cable: 100
RJ45: 30
RJ11: 0
tv plug: 100
==================

The list of items is all items in the article table and I want to put the amounts in the mutationtable.

I do find this hard to explain but I hope it's clear.

[June7]

If you want to present user with all articles for entry of a mutation value, then options are:

1. create a set of records and open form to this recordset, issue is if no value for an article then there is a blank record that must be removed

2. unbound form with 'rows' of unbound controls to enter values then code will save record for each row with a value

Either method is complicated. How many articles are there?