Search results

a bit out of practice probably a stupid question, but...do those extra tables related 1-1 w/the main permit table need a primary key also, or just the contractor/owner id as a foreign key? :o

thanx, but a bit out of practice let me give you a brief description of the whole database: i have a table for contractors/owners who will be the ones applying for the permits. there are 4 types of permits that may be purchased - it was suggested to me that i have one main permit table and...

a bit mixed up maybe i'm confused...see, the users will be entering individual amounts in each form for each permit. if there is more than one permit purchased, i would think i need a sum, wouldn't i? that's what i want to be stored in the payments table. if i am figuring this incorrectly...

thanx! i have to agree with rinelson...you guys are beyond helpful! :D

different type of calculated field that info was helpful. i do have a question though...i also need a calculated field, but once it's done, i need to store it permanently. (i'm the one with the permit db) for example, a contractor pays for more than 1 permit at a time (or just 1) with one...

thanx! thanx for all your help...i should be good to go now. i appreciate it (so will my boss)! lol. ;)

primary key question the permits are working out well...thanx for your help! i do have one other question though...when i had the owners & contractors in seperate tables, i used an autonumber as the primary key for owners & the license # for the contractors (i'd stilll like to use the license...

thanx! thanx for your help...appreciate the quick response :)

thanx for the advice...that does make more sense. my only other issue is adding the letter (m for meter permit, h for hydrant, etc.) to the permit # if they are all going to be in one table. btw, sorry for the duplicate postings...just under a bit of stress @ work. i'll make a note of it.

i am trying to create a data type for a table that includes a constant letter along with an autonumber (this will be the primary key for the table)...any suggestions? also, how do i add it as a data type in table design view? the database i'm creating will be used to store city issued permits...

the database i'm creating will be used to store city issued permits. there a 4 different types of permits that can be issued, some w/the same info (i.e. contractor, owner) and others with different data (certain permits are only issued for a specific # of days, others require a tap or meter...

i am creating a database that will include four (4) tables that need to have an autonumber as a primary key, but i need that autonumber to be preceded by a letter (one letter for each table). i am creating forms for the users to based on these tables for users to enter data. please help...i'm...

thanx for your suggestions. another question though...i need the letter to show in the forms that the users will be inputting data into (and yes, all the records will have the same letter for each table - i'm making 4 tables with 4 different letters), so how would i go about creating my own...

i am trying to create a data type for a table that includes a constant letter along with an autonumber (this will be the primary key for the table)...any suggestions? also, how do i add it as a data type in table design view? thanx!