OK, First, you need to reread the blog. You should NOT be storing the Transaction_ID. It is a calculated value. Second, your naming is what confused me. Your Passenger table should have an autonumber PassengerID. That PassengerID should be the Foreign Key in your Reservations table. Your servation table should also have an autonumber for ReservationID. I really don’t see why you need sequential numbering in the passenger table. I can understand it in the Reservations table, but not in the passenger table. Also, I don’t see any reason for a transaction date in the passenger table. I can understand a CreateDate for when the passenger signed up.
What is the max number of records that can be put into a table in Microsoft Access? Does it vary from version to version? Thanks in advance. "Mike C"
CK Note: Word 2007 - 2013 interface has an different automatic numbering scheme which I have been told is much less subject to corruption. Microsoft Word 2010 Bible by Herb Tyson, MVP. However numbering is still very imperfect in these later versions. I still recommend following Shauna Kelly's step-by-step instructions (see above) if setting up numbering in a template or in a document likely to be heavily edited. If you start without doing this and end up with "spaghetti numbering," fixing it will be a very large chore!
This tip was very helpful. Now I have been able to automatically number dozens of examples in a linguistics paper, and as I revise the paper and insert new examples between the existing examples, the numbering is automatically adjusted. Now the next step is how to use bookmarks for the references to the examples in the text of the paper. The references need to point to specific examples, and need to be automatically adjusted when the numbering of examples is adjusted. Any ideas on how to do this?
Your raffle might be subject to gaming commission or tax laws. Check with your municipality, state or province, and federal governments to make sure your raffle is legal. These government departments aren’t just enforcers. They are often great resources on how to run a successful fund raising raffle. Raffles are fun! Getting in trouble with the law or tax man is not.
See Word's Numbering Explained by John McGhie, MVP - comprehensive and not pretty (Downloadable pdf file in letter size) - Reading this is vital to anyone attempting to use automatic numbering or bullets in a law office setting or other places where the documents are likely to be reused or heavily edited. See also How to Create a Template with a downloadable template with style-based numbering.
You can add many of these items by using text variables. InDesign includes several preset variables, such as Creation Date and File Name. You can modify these variables, and you can create your own. For example, you can create a variable that displays the first use of a Heading paragraph style in the header or footer. Once you create or edit the variables you need, you assemble them on the master page to create your header and footer, and then you apply the master page to the appropriate document pages.
Scott, you’ll need to be more specific to help me. When you say “put this code behind a save button” what exactly does that mean – where do I type the code you provided? Yes, I do have a Save Button, which saves the record and closes the form (but currently has no way to save the next sequential Project ID). I want show this next Project ID (number on the entry form) and have that new number flow to the table along with the other data on the form.
One of the easiest ways to begin applying numbers is by starting to type a numbered list. Word recognizes that you are creating a list and responds accordingly by converting text that you type into numbered items. The number scheme, delimiter characters that mark the beginning or end of a unit of data and formatting are all based on what you have typed. sequential numbering printing