Sorry!
For each shipment (which has an SDNNumber (sales delivery note number) and SDNDate) there will normally be a single part number, and either many SerialNumbers each with Quantity 1, or where parts are not serialized, just 1 row with SerialNumber being blank and Quantity showing the relevant number.
Very very rarely, a SDN may have 2 different parts on it.
Does that make more sense now?
Nige
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> Nige,
> I'm not sure anyone can help you unless you describe your process of shipping etc. If you have lots of repeating values in tblSerialAndSDN, you might want to create a tblShipments and store those fields in the new table and then the primary key from tblShipments in tblSerialAndSDN.
>
> I'm not sure though since I don't know anything about your business processes etc.
>
> Duane Hookom
> MS Access MVP
>
>
>
>
> To: MS_Access_Professionals@yahoogroups.com
> From: nigel@...
> Date: Fri, 23 Sep 2011 08:27:09 +0000
> Subject: Re: [MS_AccessPros] How to speed up data entry - entry several rows of data from 1 simple form?
>
>
>
>
>
>
> Thanks Duane,
>
> The database is really simple, so changing the structure is no issue for me.
>
> There are 2 tables...
>
> tblPartDetails - fields are - ID, Customer, PartNumber, PartDescription, WarrantyPeriodMonths, WarrantyPeriodDays
> tblSerialAndSDN - fields are - ID, SerialNumber, PartNumber, SDNNumber, SDNDate, WarrantyPeriodDays, Quantity
> 1 form to enter/view/filter the data
> 1 report
>
> I think I'll get rid of the WarrantyPeriodMonths field as I'm not using it after all.
>
> Customer, PartNumber, PartDescription, WarrantyPeriodDays are included in a combo box on the form - once a selection is made the part number is inserted into the form field and table field, and WarrantyPeriodDays inserted into a hidden form field and the table field.
>
> WarrantyPeriodDays is duplicated like this in tblSerialAndSDN as I need to use it in the calculation of form fields WarrantyExpiryDate and WarrantyDaysLeft but I couldn't do that unless I used the value from the combo after inserting it into the field/table...I'm sure there is a way, but with my very limited knowledge I couldn't find it!!!
>
> Your suggestion sounds very sensible, but I'm not sure what I need to do to make it happen. Could you give me some more info please?
>
> Cheers, Nige
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> >
> >
> > Nige,
> >
> > Based on "shipment of 150 units" and "select part number and enter SDN number and date for each row, when they are all the same!" I would review the table structure where there might be this much repeating information. I don't know what your table structure is but have you considered a shipment header table with the SDN and shipment date and a shipment detail table with the shipment ID and part number?
> >
> > If you don't want to change your table structure, you can use a main form with SDN and Shipment Date and a subform with your current table. Set the Link Master and Link Child properties to the SDN adn Shipment Date. This will automatically default the values in the subform to the values from the main form.
> >
> > Duane Hookom
> > MS Access MVP
> >
> >
> >
> >
> > From: nigel@
> >
> >
> >
> >
> >
> >
> > Thanks Bill and Paul for your help - everything in my simple warranty database is now working as intended!
> >
> > Now...I have new records added one row at a time...a user clicks 'add new' to get a blank row, enters the serial number, selects the part number from a combo box, enters the SDN (delivery note) number and enters the SDN date.
> >
> > That's all great, until despatch have a shipment of 150 units, then it's laborious having to select part number and enter SDN number and date for each row, when they are all the same!
> >
> > So...I'd like to create a new form 'enter shipment' in which the user selects the part number and enters SDN number and date at the top, only once, then in a text or memo field enters all serial numbers on separate rows (by scanning bar codes, so very quick), then hit 'submit' and the database creates rows in the table for each serial number that has been scanned, using the part/sdn/date data for each.
> >
> > But, as usual, I don't know how to achieve this, so can someone point me in the right direction?
> >
> > Cheers, Nige
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar