Serial Number, 2 Tables

[LXR]

I am creating a very simple Checking Account DB, but have run into a problem with the auto entry of a Serial Number.

 

I have 2 tables: (a) Credit Table and (b) Debit Table.

 

I want to auto-enter a single serial number sequence that is shared by both tables. For example: When I create a new record in (a) the serial number is 100. When I subsequently create a new record in (b), the serial number will be 101 etc.

 

Does anyone know how to do this?

[Robert Schaub]

See Here

[Ender]

Oops--check that link, Chopper.

 

LXR, It's not clear why the serial numbers must be tied together, but one way to do this is to simply keep both credits and debits in the same table, using a Type field to distinguish between them.

 

If they needed to be viewed or edited in separate portals, you could use that Type field as a filter for two relationships to the table.

[LXR]

I have an earlier version of the DB where I used just 1 table and the problem arose where 1 user would enter a Deposit in a record and then another user would later enter a check in the same record.

 

That is why I wanted to use 2 tables. The serial number will be used to create a sort order in Table View for the Account Ledger which will display both tables as a list.

[Ender]

As I said, you can use two portals to the same table, one for debits and one for credits. But why not sort by Date/Time, and number the list with the '@@' symbol if you need numbering? I don't think the @@ symbol works in Table View, but you could use a List View.

 

Also, I think if you're using two tables, you won't be able to show both credits and debits in the same list. Did I miss something?