Return a subform value to a table with the click of a button.....

[shaztastic]

Is it possible to return a value from a subform to a table on the click of a button?

[orange]

Can you please tell us more?

[shaztastic]

Basically i am trying to make a document register which will allocate the next available number. Each document reference is made up of three parts
Project Number, Document Type and finally a unique sequential number for each Project Number and Document Type combination.

I have a form where i enter all the document information and a query that counts the project number and document type to gives me the next available number and i show this using a sub-form.

I want to return that unique number back to a table along with all the other information on the main form if this is possible.....

[orange]

And what do your tables and relationships look like? You could google "incremental numbers DMax +1" or similar for more info.

see http://www.599cd.com/tips/access/inc...r-own-counter/

There are some free data models --some related to documents - here that may be helpful.
http://www.databaseanswers.org/data_models/index.htm

[shaztastic]

Have attached screen shot of table relationships....very much still a work in progress!
Only have a limited knowledge of access so any help is much appreciated.

[shaztastic]

Our drawing numbers look something like the following:
T123/E/001
T123/E/002
T123/P/001
T123/P/002
T123/P/003
T123/I/001
T456/E/001
T456/P/001
etc,etc....

[orange]

Any particular reason? If you have to find drawings for Pennsylvania from 1998 - 2000 -- how does the coding scheme help?

Seems there must be other attributes to allow searching/retrieval by other "fields".

Quite often, if you step back and see what has to "come out of the database", you can get an idea of how it should be structured.

I see your tables like DrawnBy are not populated.

You might find the following material valuable in database design.


I have suggested videos to others to familiarize them with the concepts involved.

For erd this is a great tutorial
http://www.rogersaccesslibrary.com/T...lationship.zip

These free video tutorials describe the processes of data modelling, normalization and entity relationship diagramming. There are other videos, but this group is by the same presenter and covers an example situation. The example relates Customers, Orders and Items.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

The first few topics at this site are well worth the read.

http://www.rogersaccesslibrary.com/forum/topic238.html

Good luck with your project.