Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~2K People Reached
Favorite Forums
Member Avatar for ehrendreich

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] …

Member Avatar for ehrendreich
0
138
Member Avatar for ehrendreich

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 …

Member Avatar for kvprajapati
0
380
Member Avatar for ehrendreich

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 …

Member Avatar for ehrendreich
0
1K
Member Avatar for ehrendreich

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 …

Member Avatar for ehrendreich
0
138
Member Avatar for ehrendreich

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 …

0
65