Recent content by RodgerC

Basicly you can only have M-M, 1-M, 1-1 relationships. That is it. You are right in creating a junction table called Artist_Genre, that's the way its done in Access. So, how does the other two tables connect to this new entity? However you want. You could put a 3rd table's ID into...

When I maximize a form then close it, the form behind it is also maximized. How do I stop this from happening?

Does anyone know of a good newsletters dealing with VB6 that doesn't have too much of VB.NET stuff? All the newsletters I've seen are crammed with VB.NET stuff, and it's not even fully released yet! I'm too busy to worry about upgrading right now, especially to the extent that VB.NET demands...

Thanks for the hint Jerry, can you tell me more about why you say not to use this field as primary key?

Anyone with any ideas on how to create a custom auto-incremented number in Access to be used as a primary key? I want to have a number that starts with the last 2 digits of the current year then a 3 digit auto incremented number. ie. 01-001, 01-002, etc.

I am developing a database that needs 3 Client tables, different types of clients having different sorts of data stored. My problem is I want ClientIDs that are unique over the whole 3 tables. I'm familiar with Visual Basic so thought I'd add abit of code that incremented ClientID by one...