No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I have 3 tables in MSSQL 2008 (ABSTRACT) [INDENT]tblContacts: [/INDENT] [INDENT][INDENT]ContactID: Auto Numbering Int[/INDENT][/INDENT] [INDENT][INDENT]FName: string [/INDENT][/INDENT] [INDENT][INDENT]LName: string[/INDENT][/INDENT] [INDENT][INDENT]Address1: string[/INDENT][/INDENT] [INDENT][INDENT]Address2: String[/INDENT][/INDENT] [INDENT][INDENT]City: string[/INDENT][/INDENT] [INDENT][INDENT]State: string[/INDENT][/INDENT] [INDENT][INDENT]Zip: string[/INDENT][/INDENT] [INDENT][INDENT]ContactType: int[/INDENT][/INDENT] [INDENT]tblStaff:[/INDENT] [INDENT][INDENT]ContactID: int[/INDENT][/INDENT] [INDENT][INDENT]StaffID: AutoNumber Int[/INDENT][/INDENT] [INDENT][INDENT]Title: string[/INDENT][/INDENT] [INDENT][INDENT]Unit: string[/INDENT][/INDENT] [INDENT][INDENT](etc)[/INDENT][/INDENT] [INDENT]tblMembers:[/INDENT] [INDENT][INDENT]ContactID int[/INDENT][/INDENT] [INDENT][INDENT]ApplicationDate: string[/INDENT][/INDENT] [INDENT][INDENT]Membership Date: date/time[/INDENT][/INDENT] … |
|
I am having a problem trying to save records in a parent / child data relation. I have to tables tblContacts & tblMember. There is a fk relation on the ContactID field. The tblContacts table is the master record. I am using a set up bound windows forms controls to … |
|
I have a windows form that references two tables with a foreign key constraint issue. This form uses detail views for both tables. The tables are tblContact and tblMembers. The relation is based on the ContactID that is in both tables. The parent is in the tblContact table. I am … |
|
I am working on validating a combo box. This does have a list of possible values but also allows for editing. So for example if the user does not select one of the available cities in the list they can type it in. I have tried using the validation event … |
|
I am rather new to vb and could use some help. I am using the latest version of vb and am working with a database to add some records. Simply, I would like to have a form that adds a new record into the tblContact table then enter a few … |