« 6TH POPE Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next

Re: Something Cool To Stumble Upon...

By: Zimbler0 in 6TH POPE | Recommend this post (0)
Tue, 10 May 22 4:57 AM | 24 view(s)
Boardmark this board | 6th Edition Pope Board
Msg. 31862 of 58678
(This msg. is a reply to 31861 by Decomposed)

Jump:
Jump to board:
Jump to msg. #

Ahhhh, said the blind man.

Can I assume that when one types in a Title, that the database checks to see if it has already been entered?

'Location' reminds me of when I used to keep the shop inventory of spare parts - on a computer. Access database, and the location was a text field. And it was usually something like 'A-27-C'. Where the first character (A) was a cabinet number. The second number was either a drawer number, or a shelf space. And the third character (C) was the space inside the drawer.

'Originator' - I assume is the same as author? With a separate table for all the authors and the pull down arrow access that list making it quick and easy to assign an author. Can you add new authors on the fly?

Have you looked at subforms yet? (This would be a form, with another form on the form.)

Zim.




Avatar

Mad Poet Strikes Again.


- - - - -
View Replies (1) »



» You can also:
- - - - -
The above is a reply to the following message:
Re: Something Cool To Stumble Upon...
By: Decomposed
in 6TH POPE
Tue, 10 May 22 4:23 AM
Msg. 31861 of 58678

Zimbler0:

Re: “Is your database keeping track of where they currently are, and how many duplicates?”
Yes to both. Duplicates are identified in a report I haven't yet written, but the 'hooks' for it are in place. I'll update the 'Copy number' field based on the report. It's not yet automated.

'Where they are' is determined via the 'Location' field. In nearly all cases, 'Location' is a numbered box. Later it will usually be a shelf. The database also has a 'Locations' form that translates the box number... N6-282, for instance... into something friendlier. "A white box on the Northern wall of the barn." 'Cuz N6-282 isn't very descript.

A screenshot follows:



« 6TH POPE Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next